package com.sky.mapper;

import com.sky.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

@Mapper
public interface UserMapper {

	/**
	 * 根据openid查询微信用户是否存在
	 * @param openid
	 * @return
	 */
	@Select("select * from user where openid = #{openid}")
	User getByOpenid(String openid);

	/**
	 * 插入数据
	 * @param user
	 */
	void insert(User user);


	/**
	 * 根据id查询用户
	 * @param userId
	 * @return
	 */
	@Select("select * from user where id = #{userId}")
	User getById(Long userId);

	/**
	 * 根据指定时间查询有多少注册用户
	 * @param map
	 * @return
	 */
	Integer countByMap(Map map);
}
